if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PreservationNoticeHistoryAttachmentInsert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[PreservationNoticeHistoryAttachmentInsert]
GO

CREATE PROCEDURE dbo.[PreservationNoticeHistoryAttachmentInsert]
(
	@PreservationNoticeHistoryID int,
	@Attachment image
)
AS
SET NOCOUNT ON

INSERT INTO PreservationNoticeHistoryAttachment
(
	PreservationNoticeHistoryID,
	Attachment
) 
VALUES 
(
	@PreservationNoticeHistoryID,
	@Attachment
)
GO